index
Sunny Li
2019/11/3
Summary
There are 340 shooting incidents occurs in the United States in 2018. In total, 373 lives lost in the shooting incidents. The city with most impacted, which is the city with most occurrence of shooting incidents, is Chicago. The city with most killed people is Pompano Beach (Parkland). The city with most injured people in shooting accidents is Chicago.
Summary Table
## Selecting by num_killed## Warning: Ignoring unknown aesthetics: text| city | total_num_killed | total_num_injured |
|---|---|---|
| Pompano Beach (Parkland) | 17 | 17 |
| Chicago | 13 | 122 |
| Philadelphia | 13 | 36 |
| Thousand Oaks | 13 | 2 |
| Pittsburgh | 11 | 7 |
| Detroit | 10 | 10 |
| Santa Fe | 10 | 13 |
| New Orleans | 9 | 26 |
| Bakersfield | 7 | 4 |
| Jacksonville | 7 | 23 |
| Los Angeles | 7 | 19 |
| Orlando | 7 | 13 |
| Cleveland | 6 | 18 |
| Annapolis | 5 | 0 |
| Bloomington | 5 | 3 |
| Columbia | 5 | 0 |
| Melcroft | 5 | 0 |
| Memphis | 5 | 38 |
| Paintsville | 5 | 0 |
| Ponder | 5 | 1 |
| Robstown | 5 | 0 |
| Wilmington | 5 | 0 |
| Aberdeen | 4 | 3 |
| Antioch | 4 | 3 |
| Asheville | 4 | 3 |
| Cincinnati | 4 | 6 |
| Clearlake | 4 | 1 |
| Gallup | 4 | 1 |
| Indianapolis | 4 | 5 |
| Miami | 4 | 21 |
| Nashville | 4 | 6 |
| Palm Beach Gardens (Riviera Beach) | 4 | 10 |
| Reading | 4 | 0 |
| Saint Charles | 4 | 1 |
| Saint Louis | 4 | 34 |
| Silver Spring | 4 | 1 |
| Taft | 4 | 1 |
| Aurora | 3 | 13 |
| Baton Rouge | 3 | 1 |
| Buffalo | 3 | 11 |
| Colorado Springs | 3 | 7 |
| Dunn | 3 | 1 |
| Fort Wayne | 3 | 2 |
| Globe | 3 | 1 |
| Houston | 3 | 13 |
| Lake Worth (Lantana) | 3 | 3 |
| Las Vegas | 3 | 15 |
| Little Rock | 3 | 1 |
| Oakland | 3 | 15 |
| San Francisco | 3 | 14 |
| Stockton | 3 | 2 |
| Tallahassee | 3 | 5 |
| Timmonsville | 3 | 2 |
| Wadesboro | 3 | 1 |
| Wetumpka | 3 | 2 |
| Benton | 2 | 14 |
| Brooklyn | 2 | 11 |
| Demopolis | 2 | 2 |
| El Dorado | 2 | 2 |
| Florence | 2 | 6 |
| Gardena | 2 | 3 |
| Gary | 2 | 6 |
| Hurtsboro | 2 | 2 |
| Lima | 2 | 8 |
| Lutcher | 2 | 2 |
| Palo Alto (East Palo Alto) | 2 | 2 |
| Paterson | 2 | 6 |
| Saint Robert (St Robert) | 2 | 2 |
| Seattle (Skyway) | 2 | 2 |
| Springfield | 2 | 9 |
| Vallejo | 2 | 7 |
| Washington | 2 | 23 |
| Ashburn | 1 | 6 |
| Atlanta | 1 | 7 |
| Auburn | 1 | 4 |
| Bradenton | 1 | 5 |
| Brinkley | 1 | 3 |
| Champaign | 1 | 3 |
| Cleveland (Garfield Heights) | 1 | 5 |
| Compton | 1 | 3 |
| Denver | 1 | 8 |
| Elgin | 1 | 3 |
| Espanola (Española) | 1 | 3 |
| Eutaw | 1 | 4 |
| Fort Lauderdale (Lauderhill) | 1 | 3 |
| Hazlehurst | 1 | 7 |
| Hickory | 1 | 3 |
| Homestead (Munhall) | 1 | 3 |
| Huntsville | 1 | 7 |
| Indianapolis (Lawrence) | 1 | 4 |
| Jackson | 1 | 4 |
| Jersey City | 1 | 8 |
| Kansas City | 1 | 13 |
| Lakewood | 1 | 3 |
| Laurinburg | 1 | 3 |
| Los Angeles (Watts) | 1 | 4 |
| Macon | 1 | 3 |
| Masontown | 1 | 4 |
| Middleton | 1 | 4 |
| Minneapolis | 1 | 14 |
| Mobile | 1 | 4 |
| Monroe | 1 | 3 |
| Natchitoches | 1 | 3 |
| Oklahoma City | 1 | 7 |
| Omaha | 1 | 16 |
| Phoenix | 1 | 4 |
| Pine Bluff | 1 | 7 |
| Plano | 1 | 3 |
| Richmond | 1 | 8 |
| Rockford | 1 | 4 |
| San Bernardino | 1 | 11 |
| Sanford | 1 | 6 |
| Sunnyside | 1 | 4 |
| Talihina | 1 | 4 |
| Thornton | 1 | 3 |
| Tracy | 1 | 4 |
| Trenton | 1 | 23 |
| Union Springs | 1 | 5 |
| Virginia Beach | 1 | 9 |
| West Palm Beach | 1 | 3 |
| Westminster | 1 | 3 |
| Wichita Falls | 1 | 3 |
| Alachua | 0 | 5 |
| Albany | 0 | 8 |
| Anderson | 0 | 4 |
| Asbury Park | 0 | 5 |
| Baldwin Park | 0 | 4 |
| Baltimore | 0 | 23 |
| Birmingham | 0 | 11 |
| Boston | 0 | 4 |
| Bowling Green | 0 | 4 |
| Brandon | 0 | 6 |
| Bridgeport | 0 | 4 |
| Bronx | 0 | 8 |
| Byhalia | 0 | 4 |
| Camden | 0 | 4 |
| Charlotte | 0 | 4 |
| Chattanooga | 0 | 5 |
| Chicago Heights | 0 | 4 |
| Columbus | 0 | 9 |
| Corona (Queens) | 0 | 5 |
| Covington | 0 | 4 |
| Dallas | 0 | 11 |
| Elizabeth | 0 | 4 |
| Flint | 0 | 4 |
| Fort Smith | 0 | 4 |
| Fort Washington | 0 | 4 |
| Fort Worth | 0 | 4 |
| Greenwood | 0 | 5 |
| Hartford | 0 | 4 |
| Harvey | 0 | 4 |
| Hattiesburg | 0 | 6 |
| Hempstead | 0 | 4 |
| Henderson | 0 | 4 |
| Indiantown | 0 | 4 |
| Inglewood | 0 | 5 |
| Kannapolis | 0 | 4 |
| Lansing | 0 | 4 |
| Long Beach (North Long Beach) | 0 | 4 |
| Louisville | 0 | 7 |
| Macclenny | 0 | 4 |
| Madison | 0 | 8 |
| Maxton | 0 | 5 |
| Milwaukee | 0 | 8 |
| Modesto | 0 | 9 |
| Montgomery | 0 | 4 |
| Morganza | 0 | 4 |
| New Orleans (Algiers) | 0 | 4 |
| Paulsboro | 0 | 4 |
| Pittsburgh (East Liberty) | 0 | 4 |
| Plantation | 0 | 4 |
| Pompano Beach | 0 | 4 |
| Powell | 0 | 4 |
| Punta Gorda | 0 | 4 |
| Reddick | 0 | 4 |
| Riverside | 0 | 7 |
| Saginaw | 0 | 10 |
| Salt Lake City (West Valley City) | 0 | 4 |
| San Antonio | 0 | 13 |
| San Diego | 0 | 5 |
| Sandusky | 0 | 5 |
| Savannah | 0 | 4 |
| Shreveport | 0 | 10 |
| South Bend | 0 | 6 |
| Spartanburg | 0 | 6 |
| Stillwater | 0 | 4 |
| Swainsboro | 0 | 4 |
| Syracuse | 0 | 5 |
| Tulsa | 0 | 4 |
| Union City | 0 | 5 |
| Valley Village | 0 | 6 |
| Wartburg | 0 | 4 |
| Watertown | 0 | 5 |
| Wichita | 0 | 4 |
| Wyncote | 0 | 5 |
| York | 0 | 4 |
In the table, we can apparently see that the city with the most number of people being killed is Pompano Beach (Parkland), in which I defined as the most dangerous city. And that the city with the most people being injured in 2018 is Chicago.
Description of a particular incident
There is a car-to-car shooting event happens on December 8, 2018, near 801 S Inglewood Ave, Inglewood, California. 0 people was being killed, 5 people was being injured, including at least two boys. According to Los Angeles Sheriff’s Department, the events happened at 9pm. There are two bystander who are also caught in the gunfire. More information can be found on https://ktla.com/2018/12/09/5-people-including-2-boys-hurt-in-car-to-car-shooting-in-inglewood-area-officials/
An interactive map
- The purpose of this interactive map is to visually compare the number of being killed and number of being injured for each cities. For the cities with more people being killed and injured in shooting incidents, the map will displays as bigger circles, and vice versa.
Insights - Firstly, I observe that most of the incidents happens eastern side of the United States.
- Secondly, I observe that the murder incidents in Western United States happens most in Los Angeles.
A plot of your choice
Question: How do cities with top 10 most shooting murders compared with each other?
## Selecting by num_killed## Warning: Ignoring unknown aesthetics: text
- Why I choose pie charts?
Because I want to know the propotion of the top ten cities with most shooting murders, pie chart is the best chart to express proportionality. Each cities is distinguished with different colors, and we can easily view how each city taken up the propotion of pie chart. - Two insights
First, with the top 10 shooting murder cities, they distribute evenly compared with each other with no outliers.
Second, top 10 cities are mostly well-developed cities like Chicago, Los Angeles, Orlando, etc.